You can use this file to analyze relative costs and determine whether to buy or lease an item. Enter the data and the database performs the calculations.
How to use this solution
Experiment with different down payments or loan/lease terms (in years) to see how changes in those values can affect your decision.
How to customize this solution
Present the information graphically by exporting the data from the file and using it to create a chart in ClarisWorks or ClarisImpact.
"AxA Form View
A List View
Buy vs. Lease Summary
Information
Report Menu
A Form ViewB
Date ModifiedB
Monthly Loan PaymentB
) <> 0
2 )
Loan Percent of ValueB
Monthly Lease PaymentB
Price End LeaseB
Purchase Total PaymentsB
) <> 0
Total PaymentsB
Purchase Present ValueB
) <> 0
))) +
Lease Present ValueB
! * (((1 +
() ^
) - 1) /
()) / ((1 +
() ^
Monthly RateB
/ 100 / 12
Num PeriodsB
* 12
ItemB
Least ExpensiveB
"Purchase"
"Lease"
"No Difference"))
Purchase
Lease
No Difference22
InfoB
Created ByB
A List ViewB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Your Own
Buttonx
Your Own
Buttony
Recordz
Delete
Record{
Record|
Reports}
View As
List~
View As
Close
Least Expensive
Present Value:
Total Payments:
Purchase Price at End of Lease:
Monthly Payment:
Term (years):
Interest Rate:
Loan as % of Value:
Amount Financed:
Down Payment:
Your Own
Buttonx
Your Own
Buttony
Recordz
Delete
Record{
Record|
Reports}
View As
List~
View As
Close
Least Expensive
Present Value:
Total Payments:
Purchase Price at End of Lease:
Monthly Payment:
Term (years):
Interest Rate:
Loan as % of Value:
Amount Financed:
Down Payment:
Net Purchase Price:
Lease
Purchase
P%Enter data for Buy vs. Lease scenario
Buy vs. Lease SummaryB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Least ExpensiveY
Lease PVZ Purch. PV[
Lease Ttl.\
Purch. Ttl.]
Item^
Your Own
Button_
Your Own
Button`
Recorda
Delete
Recordb
Recordc
Reportsd
View As
Liste
View As
Formf
Closeg
Infoh9Click to see more information for a Buy versus Lease item
Infoh3Click to see more information for an inventory item
InformationB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Your Own
Buttonx
Reportsy
View As
Listz
View As
Form{
Close|
Info}
Page ##
Buy vs. Lease Summary
Purchase
Present Value
Lease
Purchase
Total Payments
Lease
Least
Expensive
Report MenuB
Your Own
ButtonI
ReportsJ
View As
ListK
View As
FormL
CloseM
InfoO,Information about the Buy vs. Lease solutionP
Info for this Solution
about the Buy vs. Lease solutionP
Info for this Solution
Your Own
ReportB
Your Own
ReportC
Your Own
ReportD
Buy vs. Lease
SummaryE
Your Own
ButtonF
ReportsG
View As
ListH
View As
FormI
CloseJ
InfoK>Click on any of these buttons to preview the respective reportL
Select a report
ButtonF
ReportsG
View As
ListH
View As
FormI
CloseJ
InfoK>Click on any of these buttons to preview the respective reportL
Select a report
5000E
34000G
29000H
05/01/95Y
05/20/95_
707.97`
.853a
17000c
38982.56d
40472e
33999.81f
32388.03h
.00666666666666667i
Office Furniturek
Lease
2500E
25000G
22500H
05/01/95Y
05/20/95_
399.32`
10000c
26459.2d
31000e
25000.25f
28547.36h
.00208333333333333i
Company Vehiclek
Purchase
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
Sort by Item
Buy vs. Lease Summary
Open Script
Sort by Item
Buy vs. Lease Summary
Open Script
Cancel
JmYou did not enter any find criteria; all records will be displayed.C+
) = 0
Cancel
JmNo records match this request.
Yesfter
Noarter
Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
wwwwww
ffffff
UUUUUU
DDDDDD
wwwwww
ffffff
UUUUUU
DDDDDD
3333B
""""""
wwxwwxw
ggvgvv
gvwxgwghg
vhgvvww
fvfgfwffv
eVefefe
VvffVefVVefUe\
ffFdeefeefddfDeVdfEdfFdffk
EUeFFEUFEUFFUeTeVFeUUdVEEk
UTdUTeETeETeEUFTUTUFTUUTeK
TEETEETUETUETUDUDEETUDTUE[
4CDD4E4ET
D4DD4CDDC
C3C3C34C4C3CC43C
"#""3"129
#11#22122"3!
""""""
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
Ejwwg
wwxwwxw
wwwwww
ffffff
UUUUUU
DDDDDD
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
wwwwww
ffffff
UUUUUU
DDDDDD
#4EWp
"4EVx
#3EVg
"4DUg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
" 234DUfw
2""2334DEVgx
3 4DEUfwx
3 DDUVgw
D EUUfwx
UDDEUUfgw
U Vfgwx
eUVfgww
"%UR
UD33D
AD@D@
AD@D@
B"#B@
B"#B"$
4"2$B"#B"#C
2$""#B"#C0
4"2#B"#C0
2$B"D0#C0
4""#C0
44444
CCCCC 44444 CCCCC
$42"
bRBBP0
@@BA@
UUUUU
(*)(%,3&
)%+@6)
",30,)%
#*>A6332+$"!
25,878
#&$690*"
!)0,++)(
"%/66435/'#
+3;4*=
!#,@9,)+,(""(-/,,*,1!
!$&(265389,#!$$
'275?
$*23/$
$),-..)''
!$&)(-5439@1!!&*-3/)!!%6B)
)220(!$*.,,.'
!$&*,*023:?B+*.,/3254.'
"++,3/(.584.,"
!#&+/-./3:9@G@60/16883)!
$++//'(9CD>4.$$
$%)*-//2693,.075-&)3792,$
")-1347<>@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<H
/2583$%+66/%
%)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
*1$&+,/3779733,
$$PQ
/004B6*
!$$ $))'/3)
%&$&.7;4
)2$)*3-)466/%$
!),02+'
%$5)%*+%$!
(+'0:==4
$+,,1643"%)"
!)/1)*+
+7=-%%&$!
!3)3=.
%&*/3113
!$$PQ
',4-%)/)
,6/%$$"
+(!<-
%),0354-
.13-&,-*
14'$$!
%))&%$!
'3*$$"
!&$%3
&%"%&
9836'
)&#%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!L
//6B&
#'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
..//.-,)'(.212PQ
",,)&%'.;<6/+',,)%!
'//,+//*)+.4:=>PQ
$(&(),5?@:2/,,''*$
-!,,%.0%)./7
#43((+9CA=3+N
&*)2!$96;;48@??PQ
)/01%$
#3/').:@<3)$&)!
/)4$%)8=A@?><@PQ
!.0/.+//./1//*
*.').3784/%
,,#%()25:<99=PQ
%10//O
0 /+134,.25653."
)++-!
# %0,*,384'%PQ
42//11/&(/563135650(
(./36$
!"23.,27-
6:=<)&931-13-!$.69433563+
,/258 #$,96-37)$!P
38;?B>;63/.22.-068934673(
,638<6$
*),/6."')==138*$)PQ
35:=@B>953-/1.-368<:8995&
%668:9(
)$'*.:&$*==8/,
-19=@CA>:83+2.,0157:
!""/88$
!)*# 6/0%
&' !$*38,.<;60"
+07=@CD=6>@.*)&(*-03;@@<-
6.3/%
#/23989=2,*%
/039>B@ "9E7,)+/3667:?CE/!"
$$%199207/
9K8@)
3933"
!0042381%$(.-)56PQ
556:=@@
5C958=BGGA96;='"+-
!!%.R
94.6BDCFM='(204967&
//2346%
$59232$PQ
:9<@?@C% 6D;;CJLONG952
(9304=FCDDE>%
$,585'
!.//11'$/;81$
9:CE><D3,5G@@HF>IF94)
$#%+*159C=:>FG)
*31*#
$/51#
89C=.!:9=C<9AFGS
CA7&(
/%3%!'+5A<6=C>$
-672.3<<961.%!
,,%=<9/69/02.
"773//33/,+)
/1$'9<3)"
069850(*)'%
%/+$
!&##34
%0<PQ
%"$:C9.*$
!+6@PQ
"$$6CD>>5
!##()
".;CPQ
%'0>GFA:378+&&%$$,&
,:CPQ
$(,0V
27CGG@6681//,)%$/
'7CPQ
!%*/1,/44CC;6547@=2*!%.$
%;CPQ
'$)=3
#%)*())3DLHB
?MB9/% !
"'6?6$
*;=PQ
$%&,9D6
!$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
!)/38;@(
"$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
+/0,$%&%%,26:5)
"$%&(/7;<=BGIJIGMG=953'%(1<<63/!
$*.8PQ
6=@?<3),3:8$
!&((),3=;::=EHIC:<F3)'""#&+/,',
#&(0PQ
FC8:CF@7/08<(
"'()*,169?:6=C=2..3'"
"%&)PQ
HD99=A@9534/
!26(%5,
! !),''*-16<@=430/,+/)!
??979>@@:-!
!$+%-*),/37<@:2/-*)+*"
4?=95;@@9&
*#%.,/136884/,)'),,%)+(%$$
/>C:13?@9)$
!!89+
!)$%*-/13321/,Z
*3*)-/0/+&$$!
6A:0,8B=1+)/68.%/(,9=2%
")$"%)-02331/31)/().241+%##!
*79/)/:<651/33)2<8.6=9.
!$%,56643/75,'&).340+&#!$$%#!
.5.)/46682%#$$-973:=<7[
!$'+4:964063+(
,33/+(&'),*)'#
"%%.2379:1&"%(&.36@?@D5
!$%')/8:86>=2)&!!-231
34772+*
&46339C@4+,3/)/:<D/8J='
"%'))+336@3(/)%#%,34569<=?CE5,)!
#'21\
.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
#,0258<?ADGE2 "'(#
"%),,/6983$
&4<9+4DD>?J>/*-6;<6,,/25.))3,'
",.0369;=AGE.
!%%(,.040'
2A?EA4*+/683*.493/($!/-,
0246689:AC7%
$%##(.23&
:96,#"%)*(%(364,%"!!"560&)/<9;989;>3$
"03., PQ
UUUUUU
wwwwww
UUUUUU
wwwwww
) = 1
) = 400
Cancel
JmYou did not enter any find criteria; all records will be displayed.C+
(.txt)